package com.huisang.springboot.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.huisang.springboot.entity.User;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface UserMapper extends BaseMapper<User> {


//    @Insert("insert into sys_user(username, password, nickname, email, phone, address) " +
//            "values(#{username}, #{password}, #{nickname}, #{email}, #{phone}, #{address})")
//    int insert(User user);
//
//    int update(User user);
//
//    @Delete("delete from sys_user where id = #{id}")
//    int delete(Integer id);
//
//    @Select("select * from sys_user")
//    List<User> getUserList();
//
//    @Select("select * from sys_user limit #{pageNum}, #{pageSize}")
//    List<User> getUserPageList(Integer pageNum, Integer pageSize);
//
//    @Select("select count(*) from sys_user")
//    int selectTotal();
}
